DB: decent_gpp_mars_dw
|
Real-time top 10 slow queries (last 15 seconds) - Updated at: 9/17/2026 3:54:55 AM
|
| Query |
Last Time (ms) |
Min Time (ms) |
Max Time (ms) |
| No queries in the last 15 seconds. |
DB: decent_gpp_mars_dw
|
Real-time top 10 quick queries (last 15 seconds) - Updated at: 9/17/2026 3:54:57 AM
|
| Query |
Last Time (ms) |
Min Time (ms) |
Max Time (ms) |
SELECT TOP(10) st.text AS Quer
yText, qs.last_elapsed_time / 10
00.0 AS LastTimeMs, qs.min_elaps
ed_time / 1000.0 AS MinTimeMs, q
s.max_elapsed_time / 1000.0 AS M
axTimeMs, qs.last_execution_time
AS LastRunTime, DB_NAME(CAST(pa
.value AS INT)) AS DatabaseName
FROM sys.dm_exec_query_stats qs
CROSS APPLY sys.dm_exec_sql_te
xt(qs.sql_handle) st CROSS APPLY
sys.dm_exec_plan_attributes(qs
.plan_handle) pa WHERE qs.last_e
xecution_time > DATEADD(SECOND,
-15, GETDATE()) AND st.text LIKE
'%tbl_%' AND pa.attribute = 'db
id' AND DB_NAME(CAST(pa.value AS
INT)) = 'decent_gpp_mars_dw' OR
DER BY qs.last_elapsed_time DESC
|
852.225 |
852.225 |
852.225 |
|